Formula Editor

Use the Formula Editor to create and edit formulas. The Formula Editor contains four main windows.

Window Description of contents

Report Fields

Report fields contain all database fields accessible for your report. They also contain any formulas or groups already created for the report.

Functions

Functions are prebuilt procedures that return values. They perform calculations such as average, sum, count, sin, trim, and uppercase.

Operators

Operators are the "action verbs" you use in formulas. They describe an operation or an action to take place between two or more values.

Examples of operators: add, subtract, less than, and greater than.

Formula text window

Area where you create or edit a formula.

Note:    Changing the syntax from Crystal syntax to Basic syntax or vice versa will change the list of functions in the Functions window as well as the list of operators in the Operators window. The functions and operators differ from syntax to syntax.

Create a formula by double-clicking on any of the components listed in the Report Fields, Functions, or Operators trees. When you choose a component, the required syntax is also inserted. You can also manually enter a formula.

When you are finished creating or editing a formula, click Check to identify any errors in the formula and click Save and Close to save the formula and return to your report.

Note:    The following shortcut keys work in the Formula Editor:

For a more complete list of shortcut keys available in the Formula Editor, see Formula Editor Key Controls.

Related topics

Creating a formula and inserting it into a report

Formula Editor buttons

Formula syntax

Operators

Functions

Specifying formulas

Formulas in action

Find dialog box (Formula Editor)



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com